---
title: "sp72347_info_page_printed_yn stored procedure documentation"
summary: "Retrieved Oracle wrapper function that returns a `Y` or `N` flag for information-page printing status."
status: draft
owner: "SAIF Claims BOF team"
last_reviewed: "2026-08-25"
source_schema: "WCIS_DBA"
source_name: "sp72347_info_page_printed_yn"
source_type: "FUNCTION"
retrieval_status: "found"
retrieval_command: "legends oracle query --name sp72347_info_page_printed_yn"
retrieval_date: "2026-08-25"
---
# sp72347_info_page_printed_yn

## Overview

| Field | Value |
| --- | --- |
| **Schema** | `WCIS_DBA` |
| **Type** | Standalone function |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.View.Policy` |
| **Calling classes** | `clsPolicyData` |

## Purpose

`sp72347_info_page_printed_yn` wraps a Boolean PL/SQL helper and exposes the result as the `Y` or `N` character flag expected by the application.

## Procedures / Methods

### sp72347_info_page_printed_yn

| Field | Value |
| --- | --- |
| **Returns** | `CHAR` |
| **Called by** | `clsPolicyData` ad hoc retrieval and `pk72846_view_policy.getpolicyperiod` / `getpolicyperiods` |
| **Description** | Returns `Y` when the information page has printed for the supplied policy period; otherwise returns `N`. |

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number to evaluate. |
| `in_policy_period_eff_date` | IN | `DATE` | — | Policy-period effective date to evaluate. |

## Business Rules

The retrieved database source embeds the following server-side rules.

| Rule ID | Summary |
| --- | --- |
| [BR-VP-033](#br-vp-033-information-page-status-is-returned-as-y-or-n) | The wrapper converts `sp72253_info_page_printed(...)` Boolean output into `Y` or `N`. |

### BR-VP-033 Information-page status is returned as Y or N

| Field | Value |
| --- | --- |
| **Statement** | The function returns `Y` when `sp72253_info_page_printed(in_policy_num, in_policy_period_eff_date)` is true and `N` otherwise. |
| **Trigger** | `SP72347_INFO_PAGE_PRINTED_YN` executes. |
| **Enforcement** | The function checks the wrapped Boolean function in an `IF ... THEN RETURN 'Y' ELSE RETURN 'N' END IF` block. |
| **Outcome** | Callers receive a character flag instead of a PL/SQL Boolean. |
| **Source** | Oracle retrieval JSON: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp72347_info_page_printed_yn.json` |

## Operations

The retrieved database source implements the following internal operations.

| Operation | Description | Trigger |
| --- | --- | --- |
| [Convert information-page Boolean result to a character flag](#convert-information-page-boolean-result-to-a-character-flag) | Call the wrapped Boolean function and return `Y` when true or `N` when false. | Caller invokes `SP72347_INFO_PAGE_PRINTED_YN`. |

### Convert information-page Boolean result to a character flag

| Field | Value |
| --- | --- |
| **Description** | Call the wrapped Boolean function and return `Y` when true or `N` when false. |
| **Trigger** | Caller invokes `SP72347_INFO_PAGE_PRINTED_YN`. |
| **Source** | Oracle retrieval JSON: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp72347_info_page_printed_yn.json` |

## Calling code references

| Class | Method | Source File |
| --- | --- | --- |
| `clsPolicyData` | `ad hoc method` | `SAIF.Business.View.Policy\clsPolicyData.vb` |

## Source Code

<details>
<summary>PL/SQL function source</summary>

```sql
FUNCTION SP72347_INFO_PAGE_PRINTED_YN
/****************************************************************
*Procedure Title  : Determine if the information page for a policy
/*                  period has printed.
*                   *** THIS IS A WRAPPER FOR SP72253 ***
*Name             : SP72347_INFO_PAGE_PRINTED_YN
*Called by        : PMS.SQL
*****************************************************************
*PROGRAMMER     ANALYST                 DATE       MOD #
*PETWIR         JOHFRE          	10/04/2001
*
*Description:	Determine if the information page for a policy
*               period has printed.
*
* INPUTS:          policy number
*                  policy period effective date
* RETURNS:         char(1) - "Y" = information page has printed
*                            "N" = information page has not printed
*
* Maintenance Log:
*   Name            Date      Description
*
******************************************************************/

	( in_policy_num	               IN	   NUMBER
	, in_policy_period_eff_date	   IN	   DATE)

    RETURN CHAR
IS
/*******************   Local Variables  *************************/

/*******************   Main Program     *************************/
BEGIN

IF sp72253_info_page_printed(in_policy_num, in_policy_period_eff_date) = TRUE THEN
     RETURN 'Y';
ELSE
     RETURN 'N';
END IF;

EXCEPTION
     WHEN others THEN
         RAISE_APPLICATION_ERROR(-20002,'Error in sp72347: '
                                  || SQLERRM);

END;   /*SP72253_INFO_PAGE_PRINTED_YN */
```

</details>

## Related documentation
- [Procedure catalog](index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)

## Sources
- Oracle retrieval JSON: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\sp72347_info_page_printed_yn.json`
- Calling code: `SAIF.Business.View.Policy\clsPolicyData.vb`
- Calling package: `C:\Users\chrfre\AppData\Local\Temp\oracle-sources\pk72846_view_policy.json`